SELECT count(*) records FROM orders;

SELECT num_rows FROM user_tables
WHERE table_name = 'ORDERS';

--this one generates an error...
SELECT count(*) records FROM "orders";
